//@ shell classic connection
|ClassicSession:<<<__mysql_uri>>>|

//@ autocomplete.nameCache update and set back to default using shell.options
||
|false|
|"autocomplete.nameCache": "false"|
||
|true|
//|"autocomplete.nameCache": "false"|

//@ batchContinueOnError update and set back to default using shell.options
||This option is read only
|false|
||Option batchContinueOnError not present in file
|false|

//@ devapi.dbObjectHandles update and set back to default using shell.options
||
|false|
|"devapi.dbObjectHandles": "false"|
||
|true|

//@ history.autoSave update and set back to default using shell.options
||
|false|
|"history.autoSave": "false"|
||
|true|

//@ history.maxSize update and set back to default using shell.options
||
|10|
|"history.maxSize": "10"|
||
|1000|

//@ history.sql.ignorePattern update and set back to default using shell.options
||
|*PATTERN*|
|"history.sql.ignorePattern": "*PATTERN*"|
||
|*IDENTIFIED*:*PASSWORD*|

//@ history.sql.syslog update and set back to default using shell.options
||
|true|
|"history.sql.syslog": "true"|
||
|false|

//@ interactive update and set back to default using shell.options
||This option is read only
|true|
||Option interactive not present in file
|true|

//@ logLevel update and set back to default using shell.options
||
|8|
|"logLevel": "8"|
||
|5|

//@ resultFormat update and set back to default using shell.options
||
|json/raw|
|"resultFormat": "json/raw"|
||
|table|

//@ passwordsFromStdin update and set back to default using shell.options
||
|true|
|"passwordsFromStdin": "true"|
||
|false|

//@ sandboxDir update and set back to default using shell.options
||
|\sandboxDir|
|"sandboxDir": "\\sandboxDir"|
||
|mysql-sandboxes|

//@ showWarnings update and set back to default using shell.options
||
|false|
|"showWarnings": "false"|
||
|true|

//@ useWizards update and set back to default using shell.options
||
|false|
|"useWizards": "false"|
||
|true|

//@ defaultMode update and set back to default using shell.options
||
|py|
|"defaultMode": "py"|
||
|none|

//@ dba.gtidWaitTimeout update and set back to default using shell.options
||
|180|
|"dba.gtidWaitTimeout": "180"|
||
|60|

//@ dba.restartWaitTimeout update and set back to default using shell.options
||
|180|
|"dba.restartWaitTimeout": "180"|
||
|60|

//@ autocomplete.nameCache update and set back to default using \option
||
|false|
|"autocomplete.nameCache": "false"|
||
|true|
//|"autocomplete.nameCache": "false"|

//@ batchContinueOnError update and set back to default using \option
||This option is read only
|false|
||Option batchContinueOnError not present in file
|false|

//@ devapi.dbObjectHandles update and set back to default using \option
||
|false|
|"devapi.dbObjectHandles": "false"|
||
|true|

//@ history.autoSave update and set back to default using \option
||
|false|
||
|true|

//@ history.maxSize update and set back to default using \option
||
|10|
||
|1000|

//@ history.sql.ignorePattern update and set back to default using \option
||
|*PATTERN*|
||
|*IDENTIFIED*:*PASSWORD*|

//@ history.sql.syslog update and set back to default using \option
||
|true|
||
|false|

//@ interactive update and set back to default using \option
||This option is read only
|true|
||Option interactive not present in file
|true|

//@ logLevel update and set back to default using \option
||
|8|
||
|5|

//@ resultFormat update and set back to default using \option
||
|json/raw|
||
|table|

//@ passwordsFromStdin update and set back to default using \option
||
|true|
||
|false|

//@ sandboxDir update and set back to default using \option
||
|\sandboxDir|
|"sandboxDir": "\\sandboxDir"|
||
|mysql-sandboxes|

//@ showWarnings update and set back to default using \option
||
|false|
|"showWarnings": "false"|
||
|true|

//@ useWizards update and set back to default using \option
||
|false|
|"useWizards": "false"|
||
|true|

//@ defaultMode update and set back to default using \option
||
|py|
|"defaultMode": "py"|
||
|none|

//@ dba.gtidWaitTimeout update and set back to default using \option
||
|120|
|"dba.gtidWaitTimeout": "120"|
||
|60|

//@ dba.restartWaitTimeout update and set back to default using \option
||
|120|
|"dba.restartWaitTimeout": "120"|
||
|60|

//@ credentialStore.helper update and set back to default using \option
||
|plaintext|
|"credentialStore.helper": "plaintext"|
||
|default|

//@ credentialStore.savePasswords update and set back to default using \option
||
|always|
|"credentialStore.savePasswords": "always"|
||
|prompt|

//@ credentialStore.excludeFilters update and set back to default using \option
||
|["user@*"]|
|"credentialStore.excludeFilters": "[\"user@*\"]"|
||
|[]|

//@ pager update and set back to default using \option
||
|more -10|
|"pager": "more -10"|
||
||

//@ connectTimeout update and set back to default using \option
||
|20.1|
|"connectTimeout": "20.1"|
||
|10|

//@ dba.connectTimeout update and set back to default using \option
||
|20.1|
|"dba.connectTimeout": "20.1"|
||
|5|

//@<OUT> List all the options using \option
 autocomplete.nameCache          true
 batchContinueOnError            false
 connectTimeout                  10
 credentialStore.excludeFilters  []
 credentialStore.helper          default
 credentialStore.savePasswords   prompt
 dba.connectTimeout              5
 dba.connectivityChecks          true
 dba.gtidWaitTimeout             60
 dba.restartWaitTimeout          60
 dba.versionCompatibilityChecks  true
 defaultCompress                 false
 defaultMode                     none
 devapi.dbObjectHandles          true
 history.autoSave                true
 history.maxSize                 1000
 history.sql.ignorePattern       *IDENTIFIED*:*PASSWORD*
 history.sql.syslog              false
 interactive                     true
 logFile                         <<<testutil.getShellLogPath()>>>
 logLevel                        5
 logSql                          error
 logSql.ignorePattern            *SELECT*:SHOW*
 logSql.ignorePatternUnsafe      *IDENTIFIED*:*PASSWORD*
 mysqlPluginDir                  [[*]]plugins
 oci.configFile                  <<<_defaultOciConfigFile>>>
 oci.profile                     DEFAULT
 pager                           ""
 passwordsFromStdin              false
 resultFormat                    table
 sandboxDir                      <<<_defaultSandboxDir>>>
 showColumnTypeInfo              false
 showWarnings                    true
 ssh.bufferSize                  10240
 ssh.configFile                  ""
 useWizards                      true
 verbose                         0

//@<OUT> List all the options using \option and show-origin
 autocomplete.nameCache          true (Compiled default)
 batchContinueOnError            false (Compiled default)
 connectTimeout                  10 (Compiled default)
 credentialStore.excludeFilters  [] (Compiled default)
 credentialStore.helper          default (Compiled default)
 credentialStore.savePasswords   prompt (Compiled default)
 dba.connectTimeout              5 (Compiled default)
 dba.connectivityChecks          true (Compiled default)
 dba.gtidWaitTimeout             60 (Compiled default)
 dba.restartWaitTimeout          60 (Compiled default)
 dba.versionCompatibilityChecks  true (Compiled default)
 defaultCompress                 false (Compiled default)
 defaultMode                     none (Compiled default)
 devapi.dbObjectHandles          true (Compiled default)
 history.autoSave                true (Compiled default)
 history.maxSize                 1000 (Compiled default)
 history.sql.ignorePattern       *IDENTIFIED*:*PASSWORD* (Compiled default)
 history.sql.syslog              false (Compiled default)
 interactive                     true (Compiled default)
 logFile                         <<<testutil.getShellLogPath()>>> (Compiled default)
 logLevel                        5 (Compiled default)
 logSql                          error (Compiled default)
 logSql.ignorePattern            *SELECT*:SHOW* (Compiled default)
 logSql.ignorePatternUnsafe      *IDENTIFIED*:*PASSWORD* (Compiled default)
 mysqlPluginDir                  [[*]]plugins (Compiled default)
 oci.configFile                  <<<_defaultOciConfigFile>>> (Compiled default)
 oci.profile                     DEFAULT (Compiled default)
 pager                           "" (Compiled default)
 passwordsFromStdin              false (Compiled default)
 resultFormat                    table (Compiled default)
 sandboxDir                      <<<_defaultSandboxDir>>> (Compiled default)
 showColumnTypeInfo              false (Compiled default)
 showWarnings                    true (Compiled default)
 ssh.bufferSize                  10240 (Compiled default)
 ssh.configFile                  "" (Compiled default)
 useWizards                      true (Compiled default)
 verbose                         0 (Compiled default)

//@ List an option which origin is Compiled default
|(Compiled default)|

//@ List an option which origin is User defined
|8|
|(User defined)|

//@ Verify error messages
||Valid values for shell mode are sql, js, py or none. (ArgumentError)
||Valid values for shell mode are sql, js, py or none.
||InvalidOption is not defined (ReferenceError)
||Unrecognized option: InvalidOption.
||No help found for filter: InvalidOption
||No help found for filter: InvalidOption

//@ Verify option dba.gtidWaitTimeout
||Malformed option value.
||value out of range
||Incorrect option value.
||
||
||

//@ Verify option dba.restartWaitTimeout
||Malformed option value.
||value out of range
||Incorrect option value.
||
||
||

//@ Verify option verbose
||Malformed option value.
||value out of range
||value out of range
||Incorrect option value.
||
||
||

//@ Verify option connectTimeout
||value out of range
||value out of range
||Incorrect option value.
||
||
||
||
||
|Value of connectTimeout is: 0|
||

//@ Verify option dba.connectTimeout
||value out of range
||value out of range
||Incorrect option value.
||
||
||
||
||
|Value of dba.connectTimeout is: 0|
||

//@ Configuration operation available in SQL mode
|Switching to SQL mode... Commands end with ;|
|8|
||The log level value must be an integer between 1 and 8 or any of [none, internal, error, warning, info, debug, debug2, debug3] respectively.
|8|
||
|5|

//@<OUT> List all the options using \option for SQL mode
 autocomplete.nameCache          true
 batchContinueOnError            false
 connectTimeout                  10
 credentialStore.excludeFilters  []
 credentialStore.helper          default
 credentialStore.savePasswords   prompt
 dba.connectTimeout              5
 dba.connectivityChecks          true
 dba.gtidWaitTimeout             60
 dba.restartWaitTimeout          60
 dba.versionCompatibilityChecks  true
 defaultCompress                 false
 defaultMode                     none
 devapi.dbObjectHandles          true
 history.autoSave                true
 history.maxSize                 1000
 history.sql.ignorePattern       *IDENTIFIED*:*PASSWORD*
 history.sql.syslog              false
 interactive                     true
 logFile                         <<<testutil.getShellLogPath()>>>
 logLevel                        5
 logSql                          error
 logSql.ignorePattern            *SELECT*:SHOW*
 logSql.ignorePatternUnsafe      *IDENTIFIED*:*PASSWORD*
 mysqlPluginDir                  [[*]]plugins
 oci.configFile                  <<<_defaultOciConfigFile>>>
 oci.profile                     DEFAULT
 pager                           ""
 passwordsFromStdin              false
 resultFormat                    table
 sandboxDir                      <<<_defaultSandboxDir>>>
 showColumnTypeInfo              false
 showWarnings                    true
 ssh.bufferSize                  10240
 ssh.configFile                  ""
 useWizards                      true
 verbose                         0

//@<OUT> List all the options using \option and show-origin for SQL mode
Switching to SQL mode... Commands end with ;
 autocomplete.nameCache          true (Compiled default)
 batchContinueOnError            false (Compiled default)
 connectTimeout                  10 (Compiled default)
 credentialStore.excludeFilters  [] (Compiled default)
 credentialStore.helper          default (Compiled default)
 credentialStore.savePasswords   prompt (Compiled default)
 dba.connectTimeout              5 (Compiled default)
 dba.connectivityChecks          true (Compiled default)
 dba.gtidWaitTimeout             60 (Compiled default)
 dba.restartWaitTimeout          60 (Compiled default)
 dba.versionCompatibilityChecks  true (Compiled default)
 defaultCompress                 false (Compiled default)
 defaultMode                     none (Compiled default)
 devapi.dbObjectHandles          true (Compiled default)
 history.autoSave                true (Compiled default)
 history.maxSize                 1000 (Compiled default)
 history.sql.ignorePattern       *IDENTIFIED*:*PASSWORD* (Compiled default)
 history.sql.syslog              false (Compiled default)
 interactive                     true (Compiled default)
 logFile                         <<<testutil.getShellLogPath()>>> (Compiled default)
 logLevel                        5 (Compiled default)
 logSql                          error (Compiled default)
 logSql.ignorePattern            *SELECT*:SHOW* (Compiled default)
 logSql.ignorePatternUnsafe      *IDENTIFIED*:*PASSWORD* (Compiled default)
 mysqlPluginDir                  [[*]]plugins (Compiled default)
 oci.configFile                  <<<_defaultOciConfigFile>>> (Compiled default)
 oci.profile                     DEFAULT (Compiled default)
 pager                           "" (Compiled default)
 passwordsFromStdin              false (Compiled default)
 resultFormat                    table (Compiled default)
 sandboxDir                      <<<_defaultSandboxDir>>> (Compiled default)
 showColumnTypeInfo              false (Compiled default)
 showWarnings                    true (Compiled default)
 ssh.bufferSize                  10240 (Compiled default)
 ssh.configFile                  "" (Compiled default)
 useWizards                      true (Compiled default)
 verbose                         0 (Compiled default)

//@<OUT> Verify options persistence WL#14246 TSFR_10_5
/path/config
10250
{
    "ssh.configFile": "/path/config",
    "ssh.bufferSize": "10250"
}

10240

//@<OUT> Verify options persistence WL#14246 TSFR_10_6
/path/config
10250
{
    "ssh.configFile": "/path/config",
    "ssh.bufferSize": "10250"
}

10240
